Shipping Charges By Zip Cd Table - FIL 44
Creating a New Shipping Charge
Example 2 - Minimum Charge plus Charge per Pound
This table, accessed via menu option FIL 44, controls a pop-up window that appears within the Order Entry and Order Change programs. It allows you to view and assign freight charges based on the following parameters:
- the type of shipping service, such as air, sea, or ground
- the carrier, such as UPS and FEDEX
- the zip code of the warehouse that is shipping the material
- The zip code where the material is being shipped to
When the rates appear in order entry or order change, you can use the information to inform a customer of shipping costs or changes in shipping costs. When a rate is selected, the charge appears as a line on the order. You can control the markup of these charges, so that a margin is made on the freight.
Use of this table automates an otherwise time consuming process, helps ensure more accurate assignments of freight, and creates a central repository that all users can share.
An example of the table is shown below.
|
Field |
Description |
|
Limit Fields |
Use these parameters to bypass any records that do not match the limit values. For example, you could limit the table to display records pertaining to a particular ship via or warehouse. If you leave these fields blank, all the shipping rates display. |
|
Opt |
Use this field to Copy, Delete , Inquire on or Update records. |
|
Ship Via |
Enter a two character ship via code if you want to position to shipping charge records for that ship via code. To access a listing of the available codes, enter a ? in the field and press Enter. |
|
Service |
This field lets you expound upon the ship via code. For example, if the ship via code is UP for UPS, you can use this field to differentiate between UPS ground and UPS air or UPS 2-Day and UPS 3-Day. |
|
From Whse |
The warehouse where the product is being shipped from. |
|
Zip Code Span |
Enter the applicable zip codes that products are being shipped to. Any zip codes within the range entered will display the established shipping rates. Zip codes can be entered to include the sort route code (e.g. 27513-0001). For our Canadian and Australian customers, the zip span can be alphanumeric, and can accommodate postal codes. |
|
LB |
Use this field when shipping charges are based on a rate per pound. Enter the shipping rate per pound in the Price field. The system automatically calculates the shipping price and cost based on the weight of the order. The Cost line, under the Price line, is your cost for these freight charges. Your price field can be set higher than your cost, indicating that you are marking up the real cost. |
|
Unit |
Use this field to base the shipping charges on units of measure. The applicable units of measure are SY, SF or M2. The system multiplies units by the rate you enter here to calculate the rate charge. The Cost line, under the Price line, is your cost for these freight charges. Because these rates are general in nature (not linked to specific items), when used automatically they are only applied to items in SF, SY, or M2. When creating rates by units, use the service and/or comments fields to describe what they apply to. For example, if you have a special carrier rate for carpet of $.50 per SY, then you could title the service GROUND/SY and include a comment such as For Carpet Only. |
|
Dollar |
This field calculates the shipping charge as a percentage of the order amount. For example, if you entered .0200, the freight charge would be 2% of the order amount. The Cost line, under the Price line, is your cost for these freight charges. |
|
Fixed Dollar |
This field allows you to establish a fixed freight rate. The Cost line, under the Price line, is your cost for these freight charges. Use Fixed Dollar rates for special services that have a flat rate, not related to weight, units, or price of order. For example, you might have a fixed rate to ship a display rack. You may also use the Fixed Dollar field in addition to the other rate fields in order to establish a minimum rate. |
|
GL Acct# and Cost Center |
The GL Acct# and Cost Center are inserted into any miscellaneous line items that are created by selecting a rate. |
|
Comment |
You can use this field to clarify an entry. For example, the comment could be For Rugs Only, Main rate from NYC, Carpet by SY, etc. |
Example Table 1
Consider the following table.
In this example, the AA ground rate is $.50 per LB. The AA air rate is $.25 per SF, and the ABC 3-day shipping rate is $.10 per dollar of the order.
If the order has the following conditions:
- total weight = 900 LBs
- total SF = 200 LBs
- total price = $8,000
If you extend the rates, the user has the following choices:
- AA Ground = $450.00 (900 LB x .50 per LB)
- AA Air = $50.00 (200 SF x .25 per SF)
- AA 3-Day = $800.00 ($8000.00 x .10)
- AA 8-Day is a fixed charge of $150.00 regardless of weight, value, etc.
- AA 27-Day is a combination of weight + fixed (900 LB x .50 per LB plus $15.00)
Creating a New Shipping Charge
- On the Shipping Charges by Zip Code Maintenance screen press F1.
- Make the necessary entries on the screen that appears.
- Press Enter to expand the screen.
- This is where you actually construct the shipping charges. Use the Per LB, Per Unit, and Per Dollar fields to set shipping charges based on the weight, number of units and price of the order. You can set one or more of these fields up.
- Fixed Dollar field allows you to establish a fixed shipping charge.
- The Cost line, under the Price line, is your cost for these shipping charges. This field is not considered when the system calculates the shipping charges for an order. However, the cost is inserted into the cost field of order entry when shipping charges are automatically added to an order.
- The Weight Limit To/From field allows you to filter the Shipping Charges Inquiry by weight to only show those services that match the weight limit. This makes this table more like the tables used by freight companies, including UPS and FEDEX.
- The GL Account and Cost Center entries direct the system where to post these shipping charges. These features allow the system to consolidate similar shipping charges into the appropriate categories for end of month posting.
- Use the Comments field to include helpful information about the shipping option.
The table uses a zip code range to calculate shipping charges. You can make this range as narrow or as broad as needed. You may also enter alpha-numeric postal codes in the zip fields.
The Weight Limit To/From field interacts with the Shipping Charges by Zip/Postal Code Inquiry (CUS 20), by limiting the shipping services shown to only those that fall within the weight limits. For an example, refer to Example 4 Filtered By Weight.
Example 2 - Minimum Charge plus Charge per Pound
This table entry is typical of many standard carriers such as UPS. The cost of the shipping charge is a fixed minimum amount of $2.40, plus an additional $.28 per pound. This table is marking up the UPS cost, so that the customer is charged $9.00 plus $.47 per pound.
Example 3 Filtered By Weight
If the Shipping Charges by Zip Code Table has from and to weight limits assigned, as shown below, the Shipping Charges by Zip/Postal Code Inquiry is filtered by weight.
These fields interact with the Shipping Charges by Zip/Postal Code Inquiry (CUS 20), by limiting the shipping services shown to only those that fall within the weight limits.
For example, a Total Weight of 4,000 lbs. falls between the weight limits of 3,000 and 6,000 lbs. set on the Shipping Charges By Zip Code Maintenance screen for service AA Ground RAL.
Shipping service AA Ground RAL appears as an option on the inquiry.
Changing the weight to under 3,000 lbs or over 6,000 lbs removes AA Ground RAL from the shipping charge inquiry.